package com.loyal.loyalerp.basedata.company.mapper.provider;

public class GyCompanyProvider {
	
	public String searchList(String searchField,String searchString,String sord) {
		String search = null;
	    search="select * from gy_company where "+searchField+" like CONCAT(CONCAT(\'%\',\'"+searchString+"\',\'%\')) order by Id "+sord;
		return search;
		
	}
	public String searchListByCompanyName(String searchField,String searchString,String sord)
	{
		String search=null;
		search="select * From gy_company where ParentId=(select Id From gy_company where CompanyName like CONCAT(CONCAT(\'%\',\'"+searchString+"\',\'%\'))) order by Id "+sord;
		return search;
	}
}
